<?php
 session_start();
 include("include/session.php");
 include("include/common.php");
 include("include/db.php");

	$sqlUser = mysql_query("SELECT * FROM software_user 
										WHERE id = '".intval($_REQUEST['user_id'])."'");
	$resUser  = mysql_fetch_array($sqlUser);
	
	$sqlUserCourses = mysql_query("SELECT * FROM software_user_courses WHERE user_id = '".intval($_REQUEST['user_id'])."'");
	while($resUserCourses = mysql_fetch_array($sqlUserCourses)){
		$arrUserCourses[]	= $resUserCourses["user_course"];		  
	}
  

 ?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title><?=TITLE_WEBSITE?></title>
<link href="css/c_energy.css" rel="stylesheet" type="text/css" />
<link href="css/logo.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="css/datepicker.css" type="text/css" />
<link rel="stylesheet" media="screen" type="text/css" href="css/layout.css" />
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/datepicker.js"></script>
<script type="text/javascript" src="js/eye.js"></script>
<script type="text/javascript" src="js/utils.js"></script>
<script type="text/javascript" src="js/layout.js?ver=1.0.2"></script>
<script type="text/javascript">
</script>
<style type="text/css">
<!--
.style4 {
	font-size: 22px;
	font-weight: bold;
}
.style6 {color: #999999}
-->
</style>
</head>
<body>

    <table width="990" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr>
        <td colspan="3" align="left" valign="top" ><? require("header.php");?></td>
</tr>
  <tr>
    <td align="center" >
	<table width="99%" cellspacing="0" cellpadding="0">
      <tr>
        <td colspan="3" align="center" valign="top">&nbsp;</td>
      </tr>
       <tr bgcolor="#FAFAFA">
        <td colspan="0" align="left" valign="top" >
		   <table width="96%" cellspacing="0" cellpadding="0">
		    <tr>
		      <td width="2%" align="left" valign="top" style="padding-left:15px" ><? require("left.php");?></td>
		      <td width="94%"  valign="top" style="padding-left:15px" >
			  <form name="signform" action="" method="post" enctype="multipart/form-data" id="signform" onsubmit="return validation();" >
			    <table id="signInTbl" width="719" cellspacing="0" cellpadding="0" style="border:solid #cccccc 1px">
                  <tr>
                    <td colspan="2" align="left" bgcolor="#373737" class="loc_search_found_term"  style="border-bottom:solid #cccccc 1px">Add/ Edit Pages </td>
                  </tr>
                  <?php
                  	if($_REQUEST['msg'] == 1)
					{
				  ?>
                  <tr style="background: #D5FFD5 " height="25">
                 	<td colspan="2"><div align="left" class="successMsg" id="err_site" style="display:block">
                       &nbsp; <strong><?='User updated successfully'?></strong>
                    </div></td>
                  </tr>
                  <?php
                  	}elseif($_REQUEST['msg'] == 2){
				  ?>
                  <tr style="background: #FFE9E9 " height="25">
                 	<td colspan="2"><div align="left" class="ErrorMsg" id="err_site" style="display:block">
                       &nbsp; <strong><?='Sorry,record does not inserted.'?></strong>
                    </div></td>
                  </tr>	
				  <?php		
					}
				  ?>
                 <tr height="30">
                    <td width="249" align="left" style="padding-left:15px">User Type</td>
                    <td width="466" align="left">
                    	<?php echo $resUser['user_type'];?>
                    </td>
                </tr>
                <tr height="30">
                    <td width="249" align="left" style="padding-left:15px">User Course</td>
                    <td width="466" align="left">
                    	<select id="user_course[]" name="user_course[]" style="width:220px" multiple="multiple"  disabled="disabled">
                       	   <?php
						    $sqlCourse = mysql_query("SELECT * FROM software_main_course where active = 'Y'");
							while($resCourse = mysql_fetch_array($sqlCourse)){
						   ?>
                           	<option value="<?php echo $resCourse["course_name"]?>" 
                          		<?php
                                	if(!empty($arrUserCourses))
									{
										if(in_array($resCourse["course_name"],$arrUserCourses)){
											echo "selected=selected";	
										}else{
											echo "";	
										}
									}
								?>  
                           ><?php echo $resCourse["course_name"]?></option>
                           
						   <?php			
							}
						   ?>
                        </select>
                    </td>
                </tr> 
                 <tr height="30">
                    <td width="249" align="left" style="padding-left:15px">Email</td>
                    <td width="466" align="left">
                      <?=$resUser['email']?>                </td>
                </tr>
                <tr height="30">
                    <td width="249" align="left" style="padding-left:15px"> Password</td>
                    <td width="466" align="left">
                      <?=$resUser['password']?>        </td>
                </tr>
				<tr height="30">
                    <td width="249" align="left" style="padding-left:15px">First Name</td>
                    <td width="466" align="left">
                      <?=$resUser['first_name']?>              </td>
                  </tr>
                   <tr height="30">
                    <td width="249" align="left" style="padding-left:15px">Last Name</td>
                    <td width="466" align="left">
                      <?=$resUser['last_name']?>           </td>
                  </tr>
                  
                   <tr height="30">
                    <td width="249" align="left" style="padding-left:15px">Mobile</td>
                    <td width="466" align="left">
                      <?=$resUser['mobile']?>           </td>
                  </tr>
                   <tr height="30">
                    <td width="249" align="left" style="padding-left:15px">Address</td>
                    <td width="466" align="left">
                      <?=$resUser['address']?>     </td>
                  </tr>
                   <tr height="30">
                    <td width="249" align="left" style="padding-left:15px">City</td>
                    <td width="466" align="left">
                      <?=$resUser['city']?></td>
                  </tr>
                   <tr height="30">
                    <td width="249" align="left" style="padding-left:15px">State</td>
                    <td width="466" align="left">
                      <?=$resUser['state']?></td>
                  </tr>
                   <tr height="30">
                    <td width="249" align="left" style="padding-left:15px">Country</td>
                    <td width="466" align="left">
                    	<?=($resCountry["country_code"])?>
                    </td>
                  </tr>
                  <tr height="30">
                    <td width="249" align="left" style="padding-left:15px">Comments</td>
                    <td width="466" align="left">
                      <?=$resUser['user_comments']?></td>
                  </tr>
                  <tr  height="30">
                    <td width="249" align="left" style="padding-left:15px">Active</td>
                    <td width="466" align="left">
                    	<?php if($resUser["active"] == 'N'){ echo 'Non-Active';}else{echo 'Active';}?>
                    </td>
                  </tr>
                   <tr  height="30">
                    <td width="249"  style="padding-left:15px" colspan="2" align="center"></td>
                  </tr>
                </table>
			    
			  </form>			  </td>
            </tr>
	        </table></td>
        </tr>
      <tr bgcolor="#FAFAFA">
        <td width="800" align="center" valign="top">&nbsp;</td>
        <td width="100" colspan="2">&nbsp;</td>
      </tr>
	    <tr bgcolor="#FAFAFA">
        <td width="800" align="center" valign="top">&nbsp;</td>
        <td colspan="2">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
</table>
</body>
</html>
